﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'U' AND name = 'MeasurementType')
	BEGIN
		DROP  Table MeasurementType
	END
GO

CREATE TABLE MeasurementType
(
   MeasurementTypeId int identity(1,1) not null,
   Description nvarchar(256) not null,
   Type nchar(1) not null
   
   constraint pkMeasurementType primary key (MeasurementTypeId),
   constraint ck_Type check (Type in ('P', 'A', 'W', 'L')) -- P=percentage, A=absolute, W=weight, L=length
)
GO  